package com.blog.dao.sys.sql;


public interface RoleSql {
		
	 //查询用户 拥有的 角色
	 String ROLE_List_Sql="SELECT r.* from chb_user u,chb_role r,chb_user_role ur  where u.id=ur.user_id and r.id=ur.role_id   and u.id=#{userId}";

	 //删除用户角色关联表
	 String DELETE_USER_ROLE=" DELETE  from chb_user_role where user_id =#{userIds}";
}
